package cn.easy.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class DeviceExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DeviceExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andDeviceIdIsNull() {
            addCriterion("device_id is null");
            return (Criteria) this;
        }

        public Criteria andDeviceIdIsNotNull() {
            addCriterion("device_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceIdEqualTo(Integer value) {
            addCriterion("device_id =", value, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdNotEqualTo(Integer value) {
            addCriterion("device_id <>", value, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdGreaterThan(Integer value) {
            addCriterion("device_id >", value, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("device_id >=", value, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdLessThan(Integer value) {
            addCriterion("device_id <", value, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdLessThanOrEqualTo(Integer value) {
            addCriterion("device_id <=", value, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdIn(List<Integer> values) {
            addCriterion("device_id in", values, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdNotIn(List<Integer> values) {
            addCriterion("device_id not in", values, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdBetween(Integer value1, Integer value2) {
            addCriterion("device_id between", value1, value2, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("device_id not between", value1, value2, "deviceId");
            return (Criteria) this;
        }

        public Criteria andDeviceDescIsNull() {
            addCriterion("device_desc is null");
            return (Criteria) this;
        }

        public Criteria andDeviceDescIsNotNull() {
            addCriterion("device_desc is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceDescEqualTo(String value) {
            addCriterion("device_desc =", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescNotEqualTo(String value) {
            addCriterion("device_desc <>", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescGreaterThan(String value) {
            addCriterion("device_desc >", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescGreaterThanOrEqualTo(String value) {
            addCriterion("device_desc >=", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescLessThan(String value) {
            addCriterion("device_desc <", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescLessThanOrEqualTo(String value) {
            addCriterion("device_desc <=", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescLike(String value) {
            addCriterion("device_desc like", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescNotLike(String value) {
            addCriterion("device_desc not like", value, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescIn(List<String> values) {
            addCriterion("device_desc in", values, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescNotIn(List<String> values) {
            addCriterion("device_desc not in", values, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescBetween(String value1, String value2) {
            addCriterion("device_desc between", value1, value2, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceDescNotBetween(String value1, String value2) {
            addCriterion("device_desc not between", value1, value2, "deviceDesc");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeIsNull() {
            addCriterion("device_longitude is null");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeIsNotNull() {
            addCriterion("device_longitude is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeEqualTo(String value) {
            addCriterion("device_longitude =", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeNotEqualTo(String value) {
            addCriterion("device_longitude <>", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeGreaterThan(String value) {
            addCriterion("device_longitude >", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeGreaterThanOrEqualTo(String value) {
            addCriterion("device_longitude >=", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeLessThan(String value) {
            addCriterion("device_longitude <", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeLessThanOrEqualTo(String value) {
            addCriterion("device_longitude <=", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeLike(String value) {
            addCriterion("device_longitude like", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeNotLike(String value) {
            addCriterion("device_longitude not like", value, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeIn(List<String> values) {
            addCriterion("device_longitude in", values, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeNotIn(List<String> values) {
            addCriterion("device_longitude not in", values, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeBetween(String value1, String value2) {
            addCriterion("device_longitude between", value1, value2, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLongitudeNotBetween(String value1, String value2) {
            addCriterion("device_longitude not between", value1, value2, "deviceLongitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeIsNull() {
            addCriterion("device_latitude is null");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeIsNotNull() {
            addCriterion("device_latitude is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeEqualTo(String value) {
            addCriterion("device_latitude =", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeNotEqualTo(String value) {
            addCriterion("device_latitude <>", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeGreaterThan(String value) {
            addCriterion("device_latitude >", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("device_latitude >=", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeLessThan(String value) {
            addCriterion("device_latitude <", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeLessThanOrEqualTo(String value) {
            addCriterion("device_latitude <=", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeLike(String value) {
            addCriterion("device_latitude like", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeNotLike(String value) {
            addCriterion("device_latitude not like", value, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeIn(List<String> values) {
            addCriterion("device_latitude in", values, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeNotIn(List<String> values) {
            addCriterion("device_latitude not in", values, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeBetween(String value1, String value2) {
            addCriterion("device_latitude between", value1, value2, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andDeviceLatitudeNotBetween(String value1, String value2) {
            addCriterion("device_latitude not between", value1, value2, "deviceLatitude");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Integer value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Integer value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Integer value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Integer value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Integer> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Integer> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Integer value1, Integer value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andDeviceStateIsNull() {
            addCriterion("device_state is null");
            return (Criteria) this;
        }

        public Criteria andDeviceStateIsNotNull() {
            addCriterion("device_state is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceStateEqualTo(Integer value) {
            addCriterion("device_state =", value, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateNotEqualTo(Integer value) {
            addCriterion("device_state <>", value, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateGreaterThan(Integer value) {
            addCriterion("device_state >", value, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("device_state >=", value, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateLessThan(Integer value) {
            addCriterion("device_state <", value, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateLessThanOrEqualTo(Integer value) {
            addCriterion("device_state <=", value, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateIn(List<Integer> values) {
            addCriterion("device_state in", values, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateNotIn(List<Integer> values) {
            addCriterion("device_state not in", values, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateBetween(Integer value1, Integer value2) {
            addCriterion("device_state between", value1, value2, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceStateNotBetween(Integer value1, Integer value2) {
            addCriterion("device_state not between", value1, value2, "deviceState");
            return (Criteria) this;
        }

        public Criteria andDeviceTagIsNull() {
            addCriterion("device_tag is null");
            return (Criteria) this;
        }

        public Criteria andDeviceTagIsNotNull() {
            addCriterion("device_tag is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceTagEqualTo(String value) {
            addCriterion("device_tag =", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagNotEqualTo(String value) {
            addCriterion("device_tag <>", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagGreaterThan(String value) {
            addCriterion("device_tag >", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagGreaterThanOrEqualTo(String value) {
            addCriterion("device_tag >=", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagLessThan(String value) {
            addCriterion("device_tag <", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagLessThanOrEqualTo(String value) {
            addCriterion("device_tag <=", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagLike(String value) {
            addCriterion("device_tag like", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagNotLike(String value) {
            addCriterion("device_tag not like", value, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagIn(List<String> values) {
            addCriterion("device_tag in", values, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagNotIn(List<String> values) {
            addCriterion("device_tag not in", values, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagBetween(String value1, String value2) {
            addCriterion("device_tag between", value1, value2, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDeviceTagNotBetween(String value1, String value2) {
            addCriterion("device_tag not between", value1, value2, "deviceTag");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalIsNull() {
            addCriterion("device_personal is null");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalIsNotNull() {
            addCriterion("device_personal is not null");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalEqualTo(Integer value) {
            addCriterion("device_personal =", value, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalNotEqualTo(Integer value) {
            addCriterion("device_personal <>", value, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalGreaterThan(Integer value) {
            addCriterion("device_personal >", value, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalGreaterThanOrEqualTo(Integer value) {
            addCriterion("device_personal >=", value, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalLessThan(Integer value) {
            addCriterion("device_personal <", value, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalLessThanOrEqualTo(Integer value) {
            addCriterion("device_personal <=", value, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalIn(List<Integer> values) {
            addCriterion("device_personal in", values, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalNotIn(List<Integer> values) {
            addCriterion("device_personal not in", values, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalBetween(Integer value1, Integer value2) {
            addCriterion("device_personal between", value1, value2, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDevicePersonalNotBetween(Integer value1, Integer value2) {
            addCriterion("device_personal not between", value1, value2, "devicePersonal");
            return (Criteria) this;
        }

        public Criteria andDeviceNameIsNull() {
            addCriterion("device_name is null");
            return (Criteria) this;
        }

        public Criteria andDeviceNameIsNotNull() {
            addCriterion("device_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceNameEqualTo(String value) {
            addCriterion("device_name =", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotEqualTo(String value) {
            addCriterion("device_name <>", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameGreaterThan(String value) {
            addCriterion("device_name >", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameGreaterThanOrEqualTo(String value) {
            addCriterion("device_name >=", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameLessThan(String value) {
            addCriterion("device_name <", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameLessThanOrEqualTo(String value) {
            addCriterion("device_name <=", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameLike(String value) {
            addCriterion("device_name like", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotLike(String value) {
            addCriterion("device_name not like", value, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameIn(List<String> values) {
            addCriterion("device_name in", values, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotIn(List<String> values) {
            addCriterion("device_name not in", values, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameBetween(String value1, String value2) {
            addCriterion("device_name between", value1, value2, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceNameNotBetween(String value1, String value2) {
            addCriterion("device_name not between", value1, value2, "deviceName");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeIsNull() {
            addCriterion("device_create_time is null");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeIsNotNull() {
            addCriterion("device_create_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeEqualTo(Date value) {
            addCriterion("device_create_time =", value, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeNotEqualTo(Date value) {
            addCriterion("device_create_time <>", value, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeGreaterThan(Date value) {
            addCriterion("device_create_time >", value, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("device_create_time >=", value, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeLessThan(Date value) {
            addCriterion("device_create_time <", value, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("device_create_time <=", value, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeIn(List<Date> values) {
            addCriterion("device_create_time in", values, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeNotIn(List<Date> values) {
            addCriterion("device_create_time not in", values, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeBetween(Date value1, Date value2) {
            addCriterion("device_create_time between", value1, value2, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("device_create_time not between", value1, value2, "deviceCreateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeIsNull() {
            addCriterion("device_update_time is null");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeIsNotNull() {
            addCriterion("device_update_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeEqualTo(Date value) {
            addCriterion("device_update_time =", value, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeNotEqualTo(Date value) {
            addCriterion("device_update_time <>", value, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeGreaterThan(Date value) {
            addCriterion("device_update_time >", value, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("device_update_time >=", value, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeLessThan(Date value) {
            addCriterion("device_update_time <", value, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("device_update_time <=", value, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeIn(List<Date> values) {
            addCriterion("device_update_time in", values, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeNotIn(List<Date> values) {
            addCriterion("device_update_time not in", values, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("device_update_time between", value1, value2, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDeviceUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("device_update_time not between", value1, value2, "deviceUpdateTime");
            return (Criteria) this;
        }

        public Criteria andDevicePicIsNull() {
            addCriterion("device_pic is null");
            return (Criteria) this;
        }

        public Criteria andDevicePicIsNotNull() {
            addCriterion("device_pic is not null");
            return (Criteria) this;
        }

        public Criteria andDevicePicEqualTo(String value) {
            addCriterion("device_pic =", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicNotEqualTo(String value) {
            addCriterion("device_pic <>", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicGreaterThan(String value) {
            addCriterion("device_pic >", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicGreaterThanOrEqualTo(String value) {
            addCriterion("device_pic >=", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicLessThan(String value) {
            addCriterion("device_pic <", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicLessThanOrEqualTo(String value) {
            addCriterion("device_pic <=", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicLike(String value) {
            addCriterion("device_pic like", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicNotLike(String value) {
            addCriterion("device_pic not like", value, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicIn(List<String> values) {
            addCriterion("device_pic in", values, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicNotIn(List<String> values) {
            addCriterion("device_pic not in", values, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicBetween(String value1, String value2) {
            addCriterion("device_pic between", value1, value2, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDevicePicNotBetween(String value1, String value2) {
            addCriterion("device_pic not between", value1, value2, "devicePic");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyIsNull() {
            addCriterion("device_key is null");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyIsNotNull() {
            addCriterion("device_key is not null");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyEqualTo(String value) {
            addCriterion("device_key =", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyNotEqualTo(String value) {
            addCriterion("device_key <>", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyGreaterThan(String value) {
            addCriterion("device_key >", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyGreaterThanOrEqualTo(String value) {
            addCriterion("device_key >=", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyLessThan(String value) {
            addCriterion("device_key <", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyLessThanOrEqualTo(String value) {
            addCriterion("device_key <=", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyLike(String value) {
            addCriterion("device_key like", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyNotLike(String value) {
            addCriterion("device_key not like", value, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyIn(List<String> values) {
            addCriterion("device_key in", values, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyNotIn(List<String> values) {
            addCriterion("device_key not in", values, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyBetween(String value1, String value2) {
            addCriterion("device_key between", value1, value2, "deviceKey");
            return (Criteria) this;
        }

        public Criteria andDeviceKeyNotBetween(String value1, String value2) {
            addCriterion("device_key not between", value1, value2, "deviceKey");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}